🕷️️ Job Radar • SCRAPING

upwork.com 🟢 2026-05-07

🔹 Refactor raw job descriptions into structured Technical Manifest
👤 Client: 🇺🇸 United States Member since 2019-05-03
💰 Price: ****
🚩 Problem: Organize and structure the data entry process from website lists to Google Sheets.
📦 Existing: Not specified

Specifications:

[Target] Populate a Google Sheet with company names, titles, contact details of key personnel.
[Method] Web scraping for data extraction followed by manual or automated data entry into Google Sheets.
[UI/UX] Not applicable
[Stack] Python (for web scraping), Google Sheets API, Apollo.io API
[Security] Ensure data privacy and security during data handling and storage. Use secure APIs and follow best practices.
[Format] JSON for structured data exchange between systems.

Workflow:

1. Obtain access to the tradeshow website containing company names.
2. Extract a list of all company names using web scraping techniques in Python.
3. Access Apollo.io API with granted credentials to retrieve contact details for target personas (CEO, VP Marketing, VP Sales & Marketing, Marketing Manager) for each company.
4. Structure the extracted data into a JSON format for easy integration.
5. Use Google Sheets API to populate the Google Sheet with structured data.